﻿-- 获取没有匹配的面部数据
create procedure [dbo].[RyFace_GetHaveNoRyInfo]
as
select mbsjlsh,sfzh,xm,sbryh,cjsj,ppsj from RyFace_Info
where sfzh is null
order by cjsj desc,sbryh